UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mSXWv8fRUVvgkJCFRNWNRGXWqUbsR7HHI7qaM1p1jc='
WHERE
key_id = 'f227e358cb58397b150ec819937ecfa17cb3b852783601d950d0d02526aaa562'
AND (
token = '8mSXWv8fRUVvgkJCFRNWNRGXWqUbsR7HHI7qaM1p1jc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)