UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qQ/FDXi9AILR08v8edyY/zjclMNcGl8QyUI1CuTVAoM='
WHERE
key_id = '3badbe2594803d2cd47b0ab9dbcba719a0b908381e0b3909193a2132ea55b3f4'
AND (
token = 'qQ/FDXi9AILR08v8edyY/zjclMNcGl8QyUI1CuTVAoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)