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