UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Iso+PfEbgfDOCmmdjeePh9hns/aLZ35SvagX4vdzf8='
WHERE
key_id = 'd647574452ce7e14fb376ab360bd0a12cae2123cd015b1262ca1768b9b7089fe'
AND (
token = '7Iso+PfEbgfDOCmmdjeePh9hns/aLZ35SvagX4vdzf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)