UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+VcLkvtQLt52kT/ms0Qdpdpqn0l0nylPZM2tRcmEbA='
WHERE
key_id = '7a331c05c2ab9a101cd84c4d775bbcf5d8bc63d52e8fc24f80191d67f785ad74'
AND (
token = 'X+VcLkvtQLt52kT/ms0Qdpdpqn0l0nylPZM2tRcmEbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)