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