UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tBRroLUZSQCAOgaKZ3AoHO6vUS1V7O6E13rN/62w6YE='
WHERE
key_id = '0d699f4e53755e8b97ec276df6a46a6e63686473617ab1bc78f9fb85453429b4'
AND (
token = 'tBRroLUZSQCAOgaKZ3AoHO6vUS1V7O6E13rN/62w6YE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)