UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D65QRJ40uk0AOsgfRatYtc81/BoRuyvcK/0VjM8eTLI='
WHERE
key_id = '46d03f9e22b70b89ed765ca4c4b76ccf1e07b5201d9a82bdc48bb395b9334560'
AND (
token = 'D65QRJ40uk0AOsgfRatYtc81/BoRuyvcK/0VjM8eTLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)