UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zzn7V7ck2dXjMU4aK/mMuhNvKxhGKYNdVGnCTffaTFo='
WHERE
key_id = '7167b6cc967f0a938f0d3dd9e31102b56e17ec98820fe43b35df0cee63e9b1d3'
AND (
token = 'Zzn7V7ck2dXjMU4aK/mMuhNvKxhGKYNdVGnCTffaTFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)