UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jN64SvaoyVqrG3Em/MAf66npR13hTkqgenSN3GNLWwA='
WHERE
key_id = '9d5bad9e4050891866addd7b93bac6d235f555cc931a363d280c2dc717d1f000'
AND (
token = 'jN64SvaoyVqrG3Em/MAf66npR13hTkqgenSN3GNLWwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)