UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wG5QIrnjO/i0GeElcDBh6AZ7AyT6d9BnoE/huhPaAnU='
WHERE
key_id = 'bb0dd2d1042e40efcdbf63fedb6aca7e9c871116aa5611d72adc2dc1e10a9f76'
AND (
token = 'wG5QIrnjO/i0GeElcDBh6AZ7AyT6d9BnoE/huhPaAnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)