UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GtHAZBmS17Y9GDgVgaLR35yAtEwLOE7rdK873m9U5Rw='
WHERE
key_id = 'ca6cdf744a50dec3a69c6076534e258c4f8062a291b16ad3db201aef03725c7f'
AND (
token = 'GtHAZBmS17Y9GDgVgaLR35yAtEwLOE7rdK873m9U5Rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)