UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5pLkZ7H8GQfNN8SS6cVaH2ILgj3DGoznRrRmxo0k3iM='
WHERE
key_id = '6641f959e43cf03b7b41ac8032d4879efa329e6b276b16044ae4372211704412'
AND (
token = '5pLkZ7H8GQfNN8SS6cVaH2ILgj3DGoznRrRmxo0k3iM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)