UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGfNLZDTfeC3FQFjYl8VLqGYqIm4W8civksGJUUCRus='
WHERE
key_id = 'ed1077b6e22448edb60dbb8aaba63b0f25293071df46f7e9d4cc31cbff32ac32'
AND (
token = 'VGfNLZDTfeC3FQFjYl8VLqGYqIm4W8civksGJUUCRus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)