UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hQ5ZJHiaJ4ggh2ln9DOgOEOSiGffCH84afjwQD25JAQ='
WHERE
key_id = '9e17e7cd9b4490c2157f38098d9f7d22d317862b65d3bfd084888696b9110f66'
AND (
token = 'hQ5ZJHiaJ4ggh2ln9DOgOEOSiGffCH84afjwQD25JAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)