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