UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/9NE/JFbgfbNbRusOp+eHIFQP5jX6brMr3IOjYrYDsI='
WHERE
key_id = 'e991ab2475df2f72c149959f1b4ae274b94b25cfb0a75e1c23e0b9bb43a69f33'
AND (
token = '/9NE/JFbgfbNbRusOp+eHIFQP5jX6brMr3IOjYrYDsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)