UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8vnpfEE/eySheEZ3eF5JzrmPIJnXGsisxiLNaIDofHo='
WHERE
key_id = '8537ea91d9d2c94e0707799bf3975ba1dc065104153a929a17c2b8abffce5abc'
AND (
token = '8vnpfEE/eySheEZ3eF5JzrmPIJnXGsisxiLNaIDofHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)