UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qqfAFKK4ACXN9NeW/M08lGfxSfC0TxBP37hLPGtdxcE='
WHERE
key_id = 'a04a0e80f46e1069fbeaa7f85634d2fbc167e4b7867b11b80d739b49fff1d715'
AND (
token = 'qqfAFKK4ACXN9NeW/M08lGfxSfC0TxBP37hLPGtdxcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)