UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TE0CYtuOD+pyn15pQ92lV1EzvITW9UemL2P8CA4jP7Y='
WHERE
key_id = 'bcfe9fc2d881c2c8403385bf9e8324a351e1b20dca00ad5b895ce21b5aa4dd54'
AND (
token = 'TE0CYtuOD+pyn15pQ92lV1EzvITW9UemL2P8CA4jP7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)