UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3ZADEko4MpFKD9O1TeZb9eCb1ffKYq+ksL90yI5W1QA='
WHERE
key_id = '219a95ba74e058ce7617e7fc7f82a2dda074a139d98688ed94cea90392cc4f19'
AND (
token = '3ZADEko4MpFKD9O1TeZb9eCb1ffKYq+ksL90yI5W1QA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)