UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIFRJLG1JX3g3BrDjwXDa5v5UNggDj3+hok1FcBURf4='
WHERE
key_id = '3f9ed5eefd7a609f07b973dff047100f4ff96ec99d534cad80bf9d1b60b71c8c'
AND (
token = 'ZIFRJLG1JX3g3BrDjwXDa5v5UNggDj3+hok1FcBURf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)