UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xd3uONzOdQZYRuW+cIbu12DYhIQTP98J15wNjYqaf9w='
WHERE
key_id = 'bdca6698484a673d5639e0901c4a43a1b017290564cefcf18b52f6b559df0574'
AND (
token = 'Xd3uONzOdQZYRuW+cIbu12DYhIQTP98J15wNjYqaf9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)