UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HrqqljKfK+sAzbA0ojVGqznDwBr56Yi2NEtUZkq6wEA='
WHERE
key_id = 'e781ef7fc5e75cc792fa96697e3e702c6c23c3b47d18f6dac299bc60a19a6be7'
AND (
token = 'HrqqljKfK+sAzbA0ojVGqznDwBr56Yi2NEtUZkq6wEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)