UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hbCL2jL5VtKpYUtlv8V3J/DjL/0PuGm1botaiK3svY='
WHERE
key_id = '44723f5267f43507c58a6f7365fcc523bb79b5a3b743142a9de1e8e193f3003f'
AND (
token = '6hbCL2jL5VtKpYUtlv8V3J/DjL/0PuGm1botaiK3svY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)