UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PU4FWDlG2YxgWNJBPOE0kblu3hCI+NNo69XFshBZ5YI='
WHERE
key_id = '7eef0a766aa1b79265c4e3d8ec80bd3c6a9ad2ae5e3dba41ca9d37273dba1f49'
AND (
token = 'PU4FWDlG2YxgWNJBPOE0kblu3hCI+NNo69XFshBZ5YI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)