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