UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hGcwLTt1MS6n/blnImoiDkoNlqarIzMwdjs1wOClX3w='
WHERE
key_id = 'dc9277fc325a97c7b20ebffdd8d6be0e8a3e042cd9003ab7026552e707d1167e'
AND (
token = 'hGcwLTt1MS6n/blnImoiDkoNlqarIzMwdjs1wOClX3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)